<html><head><title>FinishDatabaseQuery</title></head>
<body bgcolor="#EFF1F0" link="#3A3966" vlink="#000000" alink="#000000">
<font face="Verdana, sans-serif" size="2"><p align="center"><b><font size="4">FinishDatabaseQuery()</font></b></p>
<p><b>Syntax</b></p><blockquote>
<font color="#3A3966"><b>FinishDatabaseQuery</b></font>(#Database)</blockquote>

</blockquote>
<b>Description</b><br><blockquote>

Finish the current database SQL query and release its associated resources. Query related functions like 
<a href="firstdatabaserow.html">FirstDatabaseRow()</a> or <a href="nextdatabaserow.html">NextDatabaseRow()</a> can't be used anymore. 

</blockquote><p><b>Parameters</b></p><blockquote>
<style type="text/css">
table.parameters { border-spacing: 0px; border-style: none; border-collapse: collapse; }
table.parameters td { border-width: 1px; padding: 6px; border-style: solid; border-color: gray; vertical-align: top; font-family:Arial; font-size:10pt; }
</style>
<table width="90%" class="parameters">
<tr><td width="10%"><i>#Database</i></td>
<td width="90%"> 
The database to use. 

</td></tr>
</table>
</blockquote><p><b>Return value</b></p><blockquote>
None.


</blockquote><p><b>Example</b></p><blockquote>

<pre><font face="Courier New, Courier, mono"size="2">  <font color="#3A3966">; First, connect to a database with an employee table</font>
  <font color="#3A3966">;</font>
  <b><font color="#3A3966">If</font></b> <font color="#3A3966">DatabaseQuery</font>(<font color="#924B72">#Database</font>, &quot;SELECT * FROM employee&quot;) <font color="#3A3966">; Get all the records in the 'employee' table</font>
  
    <b><font color="#3A3966">While</font></b> <font color="#3A3966">NextDatabaseRow</font>(<font color="#924B72">#Database</font>) <font color="#3A3966">; Loop for each records</font>
      <b><font color="#3A3966">Debug</font></b> <font color="#3A3966">GetDatabaseString</font>(<font color="#924B72">#Database</font>, 0) <font color="#3A3966">; Display the content of the first field      </font>
    <b><font color="#3A3966">Wend</font></b>
    
<font color="#3A3966">    FinishDatabaseQuery</font>(<font color="#924B72">#Database</font>)
  <b><font color="#3A3966">EndIf</font></b>
</font></pre>

</blockquote><p><b>See Also</b></p><blockquote>

<a href="databasequery.html">DatabaseQuery()</a> 

</Blockquote><p><b>Supported OS </b><Blockquote>All</Blockquote></p><center><- <a href=examinedatabasedrivers.html>ExamineDatabaseDrivers()</a> - <a href="index.html">Database Index</a> - <a href="firstdatabaserow.html">FirstDatabaseRow()</a> -><br><br>

</body></html>